SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_AddEmail]
	
	(
	@param_Admin_LoginID VarChar(50),
	@param_sender_address VarChar(50),
	@param_topic VarChar(50),
	@param_recipients VarChar(MAX),
	@param_copy_to VarChar(MAX) ,
	@param_contents text,
	@param_sign VarChar(50),
	@param_mark VarChar(50),
	@param_add_time smalldatetime,
	@param_user_add VarChar(50),
	@param_send_state bit
	)
	
AS
	/* SET NOCOUNT ON */
	
	insert into dbo.JOL_EmailManagement_Email
	(
	Admin_LoginID,
	sender_address,
	topic,
	recipients,
	copy_to,
	contents,
	sign,
	mark,
	add_time,
	user_add,
	send_state
	)
	values
	(
	@param_Admin_LoginID,
	@param_sender_address,
	@param_topic,
	@param_recipients,
	@param_copy_to,
	@param_contents,
	@param_sign,
	@param_mark,
	@param_add_time,
	@param_user_add,
	@param_send_state
	)
	
	RETURN
GO
